# -*- coding: utf-8 -*-

###########################################################################
#
#   Copyright (c) 2020  Bresee, Inc. All Rights Reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License"
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
###########################################################################


import time
import utils.pgsql.base.pgconn as pgconn
import json

"""
position management
add 
delete
modify
...
"""
_tblName = "tbl_position"

_DB_SCRIPT = """
CREATE TABLE IF NOT EXISTS {} (
                "positionId"  SERIAL PRIMARY KEY ,  
                "caseId"  VARCHAR(64) NOT NULL default '' ,  
                "caseName" VARCHAR(64) NOT NULL default '',    
                "operatorId"   VARCHAR(64) NOT NULL default '' ,  
                "operatorName" VARCHAR(64) NOT NULL default '',    
                "province" VARCHAR(64) NOT NULL default '',    
                "position" json ,  
                "createTime" VARCHAR(32) NOT NULL default '',
                "updateTime" VARCHAR(32) NOT NULL default ''
                );
""".format(_tblName)

class PgPosition:
    def __init__(self):
        self._pgConn = pgconn.pgMainConn

    def __del__(self):
        pass

    def createTbl(self):
        """
        create
        :return:
        """
        return self._pgConn.exec(_DB_SCRIPT)

  
    def add(self,dic) -> str:
        dic["createTime"] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
        # if "lastmouthpaytpe" in dic:
        #     dic["lastmouthpaytpe"] = json.dumps(dic["lastmouthpaytpe"])
        # if "annpaytype" in dic:
        #     dic["annpaytype"] = json.dumps(dic["annpaytype"])
        sql_key = '\"' + '\", \"'.join(dic.keys()) + '\"'
        sql_val = ''
        for key in dic:
            if type(dic[key]) is str:
                sql_val = sql_val + '\'' + dic[key] + '\','
            else:
                sql_val = sql_val + str(dic[key]) + ' ,'

        
        sql = f"""insert into {_tblName} ({sql_key}) values ({sql_val[:-1]}) RETURNING "{"positionId"}" """
        return pgconn.pgMainConn.exec_fetchone(sql)
    
    def delete(self, ids) -> bool:
        sql = "delete from {} where \"positionId\" = '{}' ".format(_tblName, ids)
        return self._pgConn.exec(sql)

    
    